{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>发票编号</th>\n",
       "      <th>分店</th>\n",
       "      <th>城市</th>\n",
       "      <th>顾客类型</th>\n",
       "      <th>性别</th>\n",
       "      <th>商品类别</th>\n",
       "      <th>商品单价（美元）</th>\n",
       "      <th>购买数量（件）</th>\n",
       "      <th>购买日期</th>\n",
       "      <th>时间</th>\n",
       "      <th>支付方式</th>\n",
       "      <th>支付费用（美元）</th>\n",
       "      <th>收益（美元）</th>\n",
       "      <th>购物体验评分</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>426-39-2418</td>\n",
       "      <td>分店C</td>\n",
       "      <td>城市C</td>\n",
       "      <td>普通顾客</td>\n",
       "      <td>男</td>\n",
       "      <td>电子配件</td>\n",
       "      <td>61.41</td>\n",
       "      <td>7</td>\n",
       "      <td>2020-01-14</td>\n",
       "      <td>10:02:00</td>\n",
       "      <td>现金</td>\n",
       "      <td>429.87</td>\n",
       "      <td>21.4935</td>\n",
       "      <td>9.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>527-09-6272</td>\n",
       "      <td>分店A</td>\n",
       "      <td>城市A</td>\n",
       "      <td>会员</td>\n",
       "      <td>女</td>\n",
       "      <td>电子配件</td>\n",
       "      <td>28.45</td>\n",
       "      <td>5</td>\n",
       "      <td>2020-03-21</td>\n",
       "      <td>10:17:00</td>\n",
       "      <td>信用卡</td>\n",
       "      <td>142.25</td>\n",
       "      <td>7.1125</td>\n",
       "      <td>9.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>761-49-0439</td>\n",
       "      <td>分店B</td>\n",
       "      <td>城市B</td>\n",
       "      <td>会员</td>\n",
       "      <td>女</td>\n",
       "      <td>电子配件</td>\n",
       "      <td>12.10</td>\n",
       "      <td>8</td>\n",
       "      <td>2020-01-19</td>\n",
       "      <td>10:17:00</td>\n",
       "      <td>电子钱包</td>\n",
       "      <td>96.80</td>\n",
       "      <td>4.8400</td>\n",
       "      <td>8.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>421-95-9805</td>\n",
       "      <td>分店A</td>\n",
       "      <td>城市A</td>\n",
       "      <td>普通顾客</td>\n",
       "      <td>女</td>\n",
       "      <td>电子配件</td>\n",
       "      <td>28.96</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-02-07</td>\n",
       "      <td>10:18:00</td>\n",
       "      <td>信用卡</td>\n",
       "      <td>28.96</td>\n",
       "      <td>1.4480</td>\n",
       "      <td>6.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>811-03-8790</td>\n",
       "      <td>分店A</td>\n",
       "      <td>城市A</td>\n",
       "      <td>普通顾客</td>\n",
       "      <td>女</td>\n",
       "      <td>电子配件</td>\n",
       "      <td>45.48</td>\n",
       "      <td>10</td>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>10:22:00</td>\n",
       "      <td>信用卡</td>\n",
       "      <td>454.80</td>\n",
       "      <td>22.7400</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>828-61-5674</td>\n",
       "      <td>分店A</td>\n",
       "      <td>城市A</td>\n",
       "      <td>会员</td>\n",
       "      <td>男</td>\n",
       "      <td>运动与旅行</td>\n",
       "      <td>44.02</td>\n",
       "      <td>10</td>\n",
       "      <td>2020-03-20</td>\n",
       "      <td>19:57:00</td>\n",
       "      <td>信用卡</td>\n",
       "      <td>440.20</td>\n",
       "      <td>122.0100</td>\n",
       "      <td>9.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>670-71-7306</td>\n",
       "      <td>分店B</td>\n",
       "      <td>城市B</td>\n",
       "      <td>普通顾客</td>\n",
       "      <td>男</td>\n",
       "      <td>运动与旅行</td>\n",
       "      <td>44.63</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-01-02</td>\n",
       "      <td>20:08:00</td>\n",
       "      <td>信用卡</td>\n",
       "      <td>267.78</td>\n",
       "      <td>13.3890</td>\n",
       "      <td>5.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>630-74-5166</td>\n",
       "      <td>分店A</td>\n",
       "      <td>城市A</td>\n",
       "      <td>普通顾客</td>\n",
       "      <td>男</td>\n",
       "      <td>运动与旅行</td>\n",
       "      <td>62.13</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-22</td>\n",
       "      <td>20:19:00</td>\n",
       "      <td>现金</td>\n",
       "      <td>372.78</td>\n",
       "      <td>18.6390</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>182-52-7000</td>\n",
       "      <td>分店A</td>\n",
       "      <td>城市A</td>\n",
       "      <td>会员</td>\n",
       "      <td>女</td>\n",
       "      <td>运动与旅行</td>\n",
       "      <td>27.04</td>\n",
       "      <td>4</td>\n",
       "      <td>2020-01-01</td>\n",
       "      <td>20:26:00</td>\n",
       "      <td>电子钱包</td>\n",
       "      <td>108.16</td>\n",
       "      <td>5.4080</td>\n",
       "      <td>6.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>802-70-5316</td>\n",
       "      <td>分店A</td>\n",
       "      <td>城市A</td>\n",
       "      <td>会员</td>\n",
       "      <td>女</td>\n",
       "      <td>运动与旅行</td>\n",
       "      <td>92.13</td>\n",
       "      <td>6</td>\n",
       "      <td>2020-03-06</td>\n",
       "      <td>20:34:00</td>\n",
       "      <td>现金</td>\n",
       "      <td>552.78</td>\n",
       "      <td>127.6390</td>\n",
       "      <td>8.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            发票编号   分店   城市  顾客类型 性别   商品类别  商品单价（美元）  购买数量（件）       购买日期  \\\n",
       "0    426-39-2418  分店C  城市C  普通顾客  男   电子配件     61.41        7 2020-01-14   \n",
       "1    527-09-6272  分店A  城市A    会员  女   电子配件     28.45        5 2020-03-21   \n",
       "2    761-49-0439  分店B  城市B    会员  女   电子配件     12.10        8 2020-01-19   \n",
       "3    421-95-9805  分店A  城市A  普通顾客  女   电子配件     28.96        1 2020-02-07   \n",
       "4    811-03-8790  分店A  城市A  普通顾客  女   电子配件     45.48       10 2020-03-01   \n",
       "..           ...  ...  ...   ... ..    ...       ...      ...        ...   \n",
       "995  828-61-5674  分店A  城市A    会员  男  运动与旅行     44.02       10 2020-03-20   \n",
       "996  670-71-7306  分店B  城市B  普通顾客  男  运动与旅行     44.63        6 2020-01-02   \n",
       "997  630-74-5166  分店A  城市A  普通顾客  男  运动与旅行     62.13        6 2020-03-22   \n",
       "998  182-52-7000  分店A  城市A    会员  女  运动与旅行     27.04        4 2020-01-01   \n",
       "999  802-70-5316  分店A  城市A    会员  女  运动与旅行     92.13        6 2020-03-06   \n",
       "\n",
       "           时间  支付方式  支付费用（美元）    收益（美元）  购物体验评分  \n",
       "0    10:02:00    现金    429.87   21.4935     9.8  \n",
       "1    10:17:00   信用卡    142.25    7.1125     9.1  \n",
       "2    10:17:00  电子钱包     96.80    4.8400     8.6  \n",
       "3    10:18:00   信用卡     28.96    1.4480     6.2  \n",
       "4    10:22:00   信用卡    454.80   22.7400     4.8  \n",
       "..        ...   ...       ...       ...     ...  \n",
       "995  19:57:00   信用卡    440.20  122.0100     9.6  \n",
       "996  20:08:00   信用卡    267.78   13.3890     5.1  \n",
       "997  20:19:00    现金    372.78   18.6390     7.4  \n",
       "998  20:26:00  电子钱包    108.16    5.4080     6.9  \n",
       "999  20:34:00    现金    552.78  127.6390     8.3  \n",
       "\n",
       "[1000 rows x 14 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "data_supermarket = pd.read_excel(r'./dataset/超市销售数据.xlsx')\n",
    "data_supermarket "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 案例：统计不同类别商品的销售额，并画柱形图"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "商品类别\n",
       "健康与美容    46851.18\n",
       "居家用品     51297.06\n",
       "时尚饰品     51719.90\n",
       "电子配件     51750.03\n",
       "运动与旅行    52497.93\n",
       "食品和饮料    53471.28\n",
       "Name: 支付费用（美元）, dtype: float64"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result = data_supermarket.groupby(by='商品类别')['支付费用（美元）'].sum()\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAnQAAAFXCAYAAAArudPKAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAA/oUlEQVR4nO3debzmc/3/8cdz9jGWkRnbDGZoIbsmSwklCcVU2ijxDSm0UJESkp+krygtpsR3pL0oRSFNqahGIVkSYRhqLGPMYNbX74/X+5rzOddcZ5vlnPM587zfbtftXJ/35/1Zz3V9rtfnvX0UEZiZmZlZfQ3q6x0wMzMzsxXjgM7MzMys5hzQmZmZmdWcAzozMzOzmnNAZ2ZmZlZzDujMzMzMas4BnZmtUpIGS1Jf70dv68tjljS0r7ZdJWmoJP/OmPUCf9HMakzSSEnDuhs8SBokaeRK3od9JZ1YmT5b0q8qWT4NXCVp8Apu50+STu4iz3hJ35c0ZkW21cP9eq2kP0par2nWByVdI2lYJ8sOlXSdpN06mH+xpK93Yx9+LenN5f0Q4DZJk7u5/1tJ+o6kcZW0EZKGN+UbJGmNFstfL2lKi/QxwCzg4A62O7TVZ0JpRFPaAZK2787xmK2uHNCZ1ds1wHxgiaTo6gUsBu4CkPTJ7izT9Ppoi314GjhF0jllej7wXNnG/sDHgYsjYnHzgpKe72A7W7XYzvNl3Y1lN5C0nqTRjRcwD3ghcFY1vbzWl7RRi314WzeO+6Wd/A+2AdaJiCea0l8NzIuIBZ0s+w7gtcDGZV8k6fOVAG/pMUs6SNJnmoMgSXsAewIPA0TEIuCLwHqVPCrBf6uSuyfLflSDyq8D7f435GdnZovln6X8v6si4nHgBuDlHRz7J4FFLT6jS4Dnyv8TSZsAlwOfaDruTy/H5/fYDvbFrPaG9PUOmNkKeRf5PZ4PVB/78m7gFGAXYE4lfRBt3/vnyR/ovbu5rV+TwRsApQRHwJ+BA4ALJK3VtMwJwPsj4opSUjUoIp6vzJ8PHA7cXKbXBm6jLYj5F3BeRHy1HF/1GP8AbEAGGgCDK++3AN5eyStgOPBImVc1G5gBbNfBcT9FJZBsYWvgympCCUb2Bc6UtFdl1oyIuK/kGUoGu/cCf5O0ZdmPzYAvAK8EFlaWPRZ4shoYSxJwFjAX+IHaCmrHA7MlnVqmBwEjgA8B3y0lbfOAZ8gAag7wTUnfAoYC6wLvI8/3s2RQdntZR2Pbo4AFZfmolOh9DFijpN9Z8n62rHdeRHym5DsL+Az5P5sYEQ9IegA4ArgJmF/W+X3yM3EY7S0EfhsRS8+vpNOBZyLif5vyIunWsr9mA5IDOrMai4iHm9MkjSV/VM+IiH92svhiYGFE3F1KxJ6nfcDUMJwMOhbSPsA4hwwQqpYGj6W0BWBvSZeU9z8FJjct81hEPFCWGV3SlpS/z5b9WkZEvLCyrbOB7YHJjRIxSe8B3g/sExHPtFpHsRBYEhGzW80sQVKr0sVPAWdWpk8pb7cmS8wEHF1eAGOAr5JBHMDZZOne08CtwDAyCPwIcJ+kfSvrfkVZ50uaduN9wO7k//r0Sv4HgNMj4tIyPRwgIhqBaSOw2Y4Mxn9dPgcTgLsaQXf5XMwDbi+B5LySPpoMdKs+BFxAflaeK+fsvWQQ/ctyfEtL8iJiYVlX02qIiHheWe36I2A08MoWJZ2LqhOS9gROBQZJ+kJl1p4R8btWy5gNJA7ozAaQUmJzCTAWmFbShld+yDtyZxfz122RdjpZwjInIhZJ2gK4kSz1uQs4mQz6Pgg8RP6gNzfzGAwcp7b2XsMr6ZCB3RK6dhZwLbAfGTRClvT8totgDrLkaFAlmGylVfOU58hSwjeU6XWAB8gA8TgyyDq7kVnSZZRAStKOZOnlSRHx+eYVS9oV+Hs5HoB7gNc1At+S54XA58kg62RJH66sYm3gq5LOJwPLNYEvA408IgPHV5LVswcAd5f1j5T0WrL0d1w5notL4HV+RNxKBqFrlfPyX7KK9mQyGKtWi+8F3BoR57c4f135MVl9/pqIeErSjhHxt8r8pTcXkrYBfkKW9L6GPM+/Ah6pBHPQ+obFbEBwGzqzgeUsYFJjQtIHgD9I2qCL5dYABkeEqi/yGjGSSlVrQ0TMjognSzD3GjK4+V55DSKrAUcBdwBHRcT8iGhuazWFbPu1J1mCNZ8s5ZnXnYOVdK+kx8s2NiarfRtVdxOAt5fp2WrfUaNqNLAJWeLU6gWVqsaKxcCich5m03aOjgJeQAZQVUPL8VECk/2BgyX9TtIfJP2sHNMryRK7J8nq6MOB+4DrVdopKjs+/BC4DrgF+FxEjG68yAD6A2V6HfLmvVEy2Cgdu77s43+Ab0iaJekJZWeGzcmSv18Any37sw95o0CkucCutAXhG3TjxmEpSaOa2wNW5g0r53GPiHhE0tHAn0ug25x3TeDnwBnkZ+5nZIC5DllNbbZacEBnNkCU9lIfoH2vwm+TQcRNkl7U0bIR8VxELFMSVn64n4+IliUbkraX9F3gKuDsiDiBLIkbXqqD9wFOA74i6SpJ6zet/4SI+DCwJVnt9+Hyeqybh/0c8NGImBARE8jgZ3NgIlntvHlJP5+Oq25/0BzItnh1VYJZ9QPyf3BaCXQbhjbtww3AkWSbvm+QJVyUPE9XA7QSpP2CtoBwEdnO7r1lmdOaOhZsBlzS1NFgaU/UUpr6WzL4vpKsFn4UOLJ0ZlhABtrfIauyryB7rFar3AEOLX8nA3+RtJay9+oynS8kDVf7Hr9zaasC/Xdlv39TjnP9iPiPpIOAC4H3RsTNNCmB5S4R8SXy/7x3OZ6v0cH/3GwgckBnVnPKISa+RVah7UOWVgEQEXPIdlkzgd9L6qjhP5Iea9Er8IFO8r8c+CtZurdDRFxQZs0kG+QPLgHheWTV4aZUrjmS3irpzaW6NYAJkiaX1xvonqVBqKR3kCU1e5AlbmcCv1HbcBztglJJ57Y43pD0YuUwGa3mNVeP7lkJmhqleY9HxB/IaupPVfIOo33nir3JzgbDga2APSTtQpb8rVNKFZe+yGrRpccbEZeXksHBZPVutWT1QeCIyvQI4JjKsveRvVqPI0tRfwVsBKxRSv8a1iaD5OZAjnJe30GWHl5X9uNjZJC3oJyTgyjBJhlcnVJZxSa0dUTZsJyvGcCBZGeXfyh7pf4AOCYipjbvQ9mPTYF3SpoGTCWr+I8i2yjeL2lKaYNoNqA5oDOrMUkvA/5EVo+9IiL+0pynlGDsR7bv+o2kSc15ivnAmypBwJto30O22R3A1hFxUETc2zRvZ9oHH9eXtLmVPJ8gq8nOJKt13062yzsHuKyT7S5D0lFk28G3RMS0iHgIeBlZ6jSNtmrBqvlkO62JlRdk1el8sjF/dd6PWba3ayNwW5es4q36MvBqSTuU6eG0LzE6kGzTtjbwVjIgb1QpdlRC18oQsg1dNfjblGxD15ieRQbZP4GlVbZbAleTPWK3IXtGH0uW3DWqQtcg/2ePttjul8g2a3eQVeRfJdvqXU5be8mfUoJN8n+8tE1hKcEdRvZ8/U8JTpeQbTCHlGXPAd4VEd9SDlHT3Iu6cfyHkVWte5JB9EvJKu0zgBeR7fzMBjR3ijCrKeWwEf9Htm86NiKWaefWEBHPSNqP/NFrFdxANpTvTlrDNWQJVUfzl3QwT2WfdgKQtDUZFOwaEbNLKdXPS94htAUXHRlElvZMAa6R1AhCR5FVcJ8kg5Vmi4G5TR0NIEujGu3jqvPmsmxv10UlEFmmt2ZE3KYcKuMd5P9oJJWANiLeX5Z7APifiJhWpnfo4nibXQ58qgTNLZUq0LVo+39uQ7YzG0EG7Y1gcTY5Lt6byvQE4J6IiHJ8Kus7CHgzGTS9r+Q9PZrGGqyek2g/XE3DlsC/W6Q/QXas+XhE3FECuavI4VH2qG4nIu4HGp+lwWTP5pPI875ZRFzSvC9mA5EDOrOaioh5knaJiG51IIiIJ8mSvI6MAK5o+uGb0Un+/clqzPmN9neSXkIGL48AV0XERxqZS/upVsHkq4H7o23YkJG0DW8xvINlqpZExKcl7Q0cVNrMIelK4LmIuK+DH/OOejyqk3k9dQTwj/J+TTop8ZS0XrQNTrxOKVmrGkWe22afI6tKu9qXAyLiaoCIuFU5YO8twIcjYpqyR+p3IuJxtY0p90YycIe2kjPIdm4/jIhrJL2vrHOZoV264XXA9ObE0rniRMgBpMkAfwzwho62Uz57vyZ7u34UeKh0/jBbLTigM6uxDoK55S2KeFGLZTscMiQinm23UWljsrRoKlnV9UdllPGJ0uliAU0Duyp7VH6CLC1qWIMcfw6yWnJWN/d/BLBpJRAaBXQ2Dp+ANZVjrzWvR8CQpnlrsuz5GaK24U7Wad5A5BAfDS+gRW/hYn/gh8rBhaFUubbbWemnyyxV8gKHRsSVHcxvjAnYroQsIha3CAIXlnkXSrqRrJJ9vaTfASeXtoFExBxJhzRW39F2O6PsIHMwcEgnefYEvgvcT3Z8qFadNm/3EXIomEOB3wH3SJoU7XtWu5jOBiwHdGYDT6N0pUff786qbIuWbW6VzzA9jAzMfgV8MCLmKx9f9UPgDuV4aFOr25A0nix5eZYcqqRhK0pJVkQ0HlMmsoSmw1KgiPhFR/tI9jBtNhh4S3lVjSjzxrFsdeDdTet8JcsOsNuqh+dGZX2PNKWvQ3YIOJLsxfmEpM2a8jSOfSOyRK1Zd0uhWgXng4CfS1pEfl7mlG2+GriYrKq+ixxf8FpJ74qIK2BpT1vIdnDDynLrkueuMW8oMKIEvSr5ZpcSuM+TbfOuquzPEGBwuTk4jezF+zXghBalbUNpH1BDjkV4LXmudwGGV0obB+PfPBvA3CnCbOBpBBRdVVWO7M7KJL1b0rVkO7XqYK4flvQn8kf5MOB9EfHu8mNNRDwK7AX8LzmC/+OSvl2WfSlZFbkWOWDuHEm7SnqeHI7jB5XtfK1sY2vKc2grOv2BlrS1pGvIno/NHRqGAf/X1Dv0adoClAeb5h1FDvbbMJwcuLgxfx2yd+nSUiDl80ZvJAdu/kpp71U1mAyWdmkESiz7fxlFnquJZFVns6FkVXlnz/CF1tf7kWQ15mhygORhks4kO5i8OyJuiIhFEfFJ4P+RHVuaLQ3oyP/1g+X1ABnwHlPeN9J2LTcB6wGnRPvhcq4AHicDslcDb46I4zuoOh1CW0Dd/LqDDEiradvggM4GMEXr4aXMbICT9DngHY02Z53k25/s4XkL8PaIeKSkv5JsQH9lRNzWxTqGk2OVzYyIG0vaBylttir5jgR+HxF3V9JeTQYSv46I6U3r/Rfw2SiPuGqx3SFkR4QHyTHWbuxsP1e2ErhuCPwlun5iRWfrWR+YFS0u2JLm0b0q16Vt6LrY1nByHMHOejivcpLU6ngr8z9NPkVir26u71bg4ohoHvDZbEBwQGdmnZI0iDLGcF/vy/KQtH5T26sBpVTbPru6dQAoVa0jovuDUJsNaA7ozMzMzGrObejMzMzMam61biA6ZsyYmDBhQl/vhpmZmVmXbrnllscjYmyreat1QDdhwgSmT19mTEszMzOzfkfSgx3Nc5WrmZmZWc05oDMzMzOrOQd0ZmZmZjXngM7MzMys5hzQmZmZmdWcAzozMzOzmnNAZ2ZmZlZzDujMzMzMas4BnZmZmVnNOaAzMzMzqzkHdGZmZmY154DOzMzMrOZ6PaCTdJekx8rr4aZ5R0i6tDJ9TMk3XdLE5U03MzMzG8h6NaCTtAYQEbFheY2vzBsLnFuZ3hY4FdgJOB64cHnSzczMzAa6Ib28ve2Bv3cw74vAdZXpycDUiJgJzJQ0RtKonqZHxLxVdCxmZmZm/UJvV7nuCOwuaaak+yQdCCBpH2A8MKWSdzxwe2V6JrDZcqSbmZmZDWi9HdDNBU6KiI2BQ4FvSFoHOA84CohK3sHAnMr0PGD0cqS3I+no0sZu+qxZs1bwcMzMzMz6Xq8GdBExNSK+Xd7fDDwIXAFcFhH3NmV/ivYB2UhgyXKkN+/DlIiYFBGTxo4duyKHY2ZmZtYv9HaniMMkDaskjQN2AU6U9BjwE+Dtkn4CTAd2K8uJ7OzwyHKkm5mZmQ1ovd0pYg9gnKQLgCOABcALImI+gKS9gMMj4nBJawPnSboB2AZ4IiJmSLqmJ+m9fHxmZmZmva63A7pTgB+Wv38FDmwEc80iYo6kg8mhTOaTbe56nG5mZmY20Ckius41QE2aNCmmT5/e17thZmZm1iVJt0TEpFbz/OgvMzMzs5pzQGdmZmZWcw7ozMzMzGrOAZ2ZmZlZzfV2L1czMzOrszPO6Os96J9OO61PN+8SOjMzM7Oac0BnZmZmVnMO6MzMzMxqzgGdmZmZWc05oDMzMzOrOQd0ZmZmZjXngM7MzMys5hzQmZmZmdWcAzozMzOzmnNAZ2ZmZlZzDujMzMzMas4BnZmZmVnNOaAzMzMzqzkHdGZmZmY154DOzMzMrOYc0JmZmZnV3JC+3gEzM7OV7owz+noP+qfTTuvrPbBVxCV0ZmZmZjXngM7MzMys5hzQmZmZmdWcAzozMzOzmuv1gE7SXZIeK6+HS9rJkp6WNFvSiZW8x5R80yVNXN50MzMzs4GsV3u5SloDiIjYsJK2G/BOYEdgBHCzpB8Ao4FTgZ2AzYALgQMkbduT9N45MjMzM7O+09vDlmwP/L0p7VngkIi4H0DSA8DGwOuAqRExE5gpaYykUcDknqRHxLzeODAzMzOzvtLbVa47ArtLminpPkkHRsRtEfEPAEkbA5sAdwDjgdsry84kS956mm5mZmY2oPV2QDcXOCkiNgYOBb4haXhl/lnARaVUbTAwpzJvHlkN29P0diQdXdrYTZ81a9aKHo+ZmZlZn+vVKteImFp5f7OkB8lq2D9L2g/YHdihZHmK9gHZSGDJcqQ378MUYArApEmTYgUOx8zMzKxf6NUSOkmHSRpWSRoHLJG0CfBN4NBKm7fpwG5lOZGdHR5ZjnQzMzOzAa23O0XsAYyTdAFwBLCA7CRxM3BuRPy5kvca4DxJNwDbAE9ExAxJPUrvvUMzMzMz6xu9HdCdAvyw/P0rcCDwerKadSNJJ5d8x0bEjyUdDJwLzCfb3BERc3qSbmZmZjbQ9XYbuv8CezYl/x1QB/lvItvVrVC6mVm/c8YZfb0H/dNpp/X1HpjVUm+X0JlZnTjoaM1Bh5n1M36Wq5mZmVnNOaAzMzMzqzkHdGZmZmY154DOzMzMrOYc0JmZmZnVnAM6MzMzs5rzsCVWbx5WozUPq2FmtlpxCZ2ZmZlZzTmgMzMzM6s5B3RmZmZmNeeAzszMzKzmHNCZmZmZ1ZwDOjMzM7Oac0BnZmZmVnMO6MzMzMxqzgGdmZmZWc05oDMzMzOrOQd0ZmZmZjXngM7MzMys5hzQmZmZmdWcAzozMzOzmnNAZ2ZmZlZzDujMzMzMas4BnZmZmVnNOaAzMzMzqzkHdGZmZmY11+sBnaS7JD1WXg+XtGPK9HRJEyt5V0q6mZmZ2UA2pDc3JmkNICJiw0ratsCpwE7AZsCFwAErK72XDs3MzMysz/RqQAdsD/y9KW0yMDUiZgIzJY2RNGplpUfEvF45MjMzM7M+0ttVrjsCu0uaKek+SQcC44HbK3lmkiVsKyvdzMzMbEDr7YBuLnBSRGwMHAp8AxgGzKnkmQeMBgavpPR2JB1d2thNnzVr1godjJmZmVl/0KtVrhExtfL+ZkkPAhNoH3iNBJYAT62k9OZ9mAJMAZg0aVIs35GYmZmZ9R+9WkIn6TBJwypJ44BfAruV+SI7NTwCTF9J6WZmZmYDWm93itgDGCfpAuAIYAHwdeBOSTcA2wBPRMQMSdcA561oei8fn5mZmVmv6+2A7hTgh+XvX4EDI+JpSQcD5wLzybZ1RMSclZFuZmZmNtD1dhu6/wJ7tki/Cdh9VaWbmZmZDWR+9JeZmZlZzTmgMzMzM6s5B3RmZmZmNeeAzszMzKzmHNCZmZmZ1ZwDOjMzM7Oac0BnZmZmVnMO6MzMzMxqzgGdmZmZWc05oDMzMzOrOQd0ZmZmZjXngM7MzMys5hzQmZmZmdWcAzozMzOzmnNAZ2ZmZlZzDujMzMzMas4BnZmZmVnNOaAzMzMzq7khnc2UNBJ4BBgXEc9J2g4YCyysZgOGRMSvJR0E7BwRn1xle2xmZmZm7XQa0AHPA6PLX4CPAK8FHm/KN0fSs8DlwFkrcwfNzMzMrHOdBnQREZIAtpX095J8LnAFsDAiHmvklfRb4PyIOHtV7ayZmZmZLaurErqG6cA8sqr1b8AZwOGSngHuAa4BPgDcvSp20szMzMw61p1OEQGMAl4B3FrSPg68CNgdOBPYCPhlmTYzMzOzXtRVp4hhZKcHIuIuSY8AxwGTW2Q/ALhC0qERcfPK3lEzMzMza62rKlcB/1eZ/jbwR2BBmR5MlvINj4jbJR0JfEfSdhExd6XvrZmZmZkto6tOEfOBIyQ9KykiYpSkv0XEk5IGA9OAgyLiyZL/N5K+Dcxf5XtuZmZmZkD3BxZeCGxV3t8j6UDgbWX56yU9LOnfkh4GjomIhR2tqEHSEZIuLe8/XdbxsKQjKnmOkfSYpOmSJi5vupmZmdlA1lUbuo2A3YDFEfFQSQ6yI8SGwGHA14FDyerZq4A3dLVRSWPJ4U9+LmkbYE9gM2Bj4BZJVwPrA6cCO5V5FwIHSNq2J+ndOgtmZmZmNdZVG7ovAO8Anpb0YmATYC7wUeBXwEPkcHW/BZC0sPG+C18ErivvtwKmR8RiYIakB8lg8UBgakTMBGZKGiNpFNkho9vpETGve6fCzMzMrJ66qnI9kyw1E/mEiKvJjhBvAC4hAzMkvUrSnsAQSa/qbIWS9gHGA1NK0p3AgZI2KsuOAe4qeW6vLDqTLHnrabqZmZnZgNZVp4i7AZSPi7gKeBr4EhkIHkkGeGuXNIB/A98EXtJqfeXZsOcBbwbGleQ7gRnAL4C1gC9ExILS6WJOZfF55GPIeprevA9HA0cDbLrppp0dvpmZmVktdLdTxNrAA8B6ZHu3dwJbAF8je7TuFBE7RsT2EdEymCtOAy6LiHsraYcD/46InchAcLKklwNP0T4gGwksWY70diJiSkRMiohJY8eO7fSgzczMzOqgu4/+GkWOPaeIWCRp54i4X9K/gf0jIrq5njcCYySdAAwjg67NgCsBImKJpFuBSeTjxl4FXF5KCHcCHlmOdDMzM7MBrVsBXUQ81zR9f/m7GLituxuLiK0b7yXtRZbO3Q28XdI0YF2y9O+dZb3nSboB2AZ4IiJmSLqmJ+nd3TczMzOzuuoyoJM0BHhLRHy/xbwfAUdFxFMrsA9fAV4G/I4c7+5rEXFjWf/B5PAm88mhUYiIOT1JNzMzMxvoulNCNwS4QNJPgHOAk4CLgPcD+wMh6fXA82SbtUHAiIj4ZWcrjYhp5JMmAN7aQZ6bgN1XNN3MzMxsIOsyoIuI5yU9Tw5dcnxEnCDpPcAxZLu6Z8jerksXKX8Hr+ydNTMzM7NldbeX65KIWEAOKgxAmV5S2tEREYMiYhDZccLBnJmZmVkv6W5A19Cd3qzd7fFqZmZmZitBV89yPZB8csOakg4DhpW/NKZX/S6amZmZWWc6LKErvVvPLnnWBc4gx407o2Q5AxixqnfQzMzMzDrXYUAXEYuA7SLim8CMiJgIPF3+Uv7O6Wh5MzMzM+sdnbaha3R4MDMzM7P+q6s2dJOBh3tnV8zMzMxseXQ1Dt1xwJ7AM5I+DYwof1WZfg2Z8EZyrLrG+6tdwmdmZma26nVV5fpaYG/gH8DpwCLg1eRjuvYhn7f6UuBZ4OvAl4DHgO8Aa6yqnTYzMzOzNt15UsTvgFdJOoZ89NfjwHsjotoh4sJVtH9mZmZm1oVuDywcEV8HXgZsARywyvbIzMzMzHqkyxI6SYqIAIiIf0l6udvGmZmZmfUfXQZ0wOmSXgScFBEzgM9Kmg8saZF3CfCbiPjDytxJMzMzM+tYdwK6W4DdgH9K2hc4EfgFsD9wdcmzP3ANsBHZM3bDlb+rZmZmZtZKdzpF/Az4maTdgHuAuRHxJklPRcSbAMr7yZLGAndIGhMRj6/aXa+RM87oOs/q6LTT+noPzMzMBoSuBhb+KjAfiEZSB1kbbexmSdo8IuatvF00MzMzs8501ct1GDCUDOQ6CubacTBnZmZm1rs6LaGLiCMb7yXtA1wPvKcxexXul5mZmZl1U3eGLdkF+AKwE7ArMFrSk5W/NL0nIl6wKnbWzMzMzJbVnV6ubwYeAd4WEY9K2h14Hmg1Ft0gYORK3D8zMzMz60J3ermeJGkN8ikRj0bEHwEk7QzsEhFfLtPrRsRTq3RvzczMzGwZ3X301ybArwAkXSlpS2BH4AMl7QXA3ZIOXCV7aWZmZmYd6mrYkl2AjYFbgQUleQywMzARGCrpVWQP2EuBb0naOSLuX1U7bGZmZmbtdVXleiawN3AvbY/6Wgz8P2A4sBYwtZJ/FPA1YN+Vu5tmZmZm1pGuArr9gXcCHwfWkfRRYASwH1lK98GI2L6RWdLawOBVtK9mZmZm1kKnbegiYlFEXEa2l/sicA5wKnA32fP1D03553S3Y4SkIyRdWpkeLekhSZtX0o6R9Jik6ZImLm+6mZmZ2UDWrU4RJbD7KPCyiLg2IhZGxC8j4gPLs9HyzNdzm5I/C3y30f5O0rZk8LgTcDxw4fKkm5mZmQ103RmHbqmIuHUlbfeLwHWNCUk7kuPdbVnJMxmYGhEzgZmSxkga1dN0P4rMzMzMBrruDluy0pRHiI0HplSSLwDmAN+W9H5JKnlur+SZCWy2HOlmZmZmA1qPSuhWlKSRwHlkady4kvYK4BXAx4AZwOfI58QOJoO8hnnA6OVIb96Ho4GjATbddNMVPSQzMzOzPterAR1wGnBZRNwraVxJ2wW4KiK+CFCqT98G3En7gGwkOXTKUz1MbyciplBKBydNmhQrekBmZmZmfa23q1zfCJwo6THgJ8DbgU8DD1XyPA/MBqYDuwGUKtidyJ61PU03MzMzG9B6tYQuIrZuvJe0F3A4cDbws9LzdS5wJPBD4BrgPEk3ANsAT0TEDEk9Su+1gzMzMzPrI71d5bqMiLhH0lnkmHbrAVcBF0fEYkkHk8ObzAcOLfnn9CTdzMzMbKDrs4AuIqYB08r7qbR/hFgjz03A7iuabmZmZjaQ9fqwJWZmZma2cjmgMzMzM6s5B3RmZmZmNeeAzszMzKzmHNCZmZmZ1ZwDOjMzM7Oac0BnZmZmVnMO6MzMzMxqzgGdmZmZWc05oDMzMzOrOQd0ZmZmZjXngM7MzMys5hzQmZmZmdWcAzozMzOzmnNAZ2ZmZlZzDujMzMzMas4BnZmZmVnNOaAzMzMzqzkHdGZmZmY154DOzMzMrOYc0JmZmZnVnAM6MzMzs5pzQGdmZmZWcw7ozMzMzGrOAZ2ZmZlZzTmgMzMzM6u5PgvoJB0h6dLO0iQdI+kxSdMlTVzedDMzM7OBrE8COkljgXM7S5O0LXAqsBNwPHDh8qSbmZmZDXRD+mi7XwSu6yJtMjA1ImYCMyWNkTSqp+kRMW8VH4uZmZlZn+r1EjpJ+wDjgSmdpZXp2yvTM4HNliPdzMzMbEDr1YBO0kjgPOAoIDpKKwYDcyrT84DRy5HevA9HlzZ202fNmrVCx2NmZmbWH/R2Cd1pwGURcW8XaQBP0T4gGwksWY70diJiSkRMiohJY8eOXb6jMDMzM+tHersN3RuBMZJOAIaRQdcI4L/VNElrA98HXgVcLklkZ4dHgOk9TDczMzMb0Ho1oIuIrRvvJe0FHB4Rh7dKK0HdeZJuALYBnoiIGZKu6Ul67xyZmZmZWd/pq16uXYqIOZIOJocymQ8cujzpZmZmZgNdnwV0ETENmNZZWkTcBOzeYtkepZuZmZkNZH70l5mZmVnNOaAzMzMzqzkHdGZmZmY154DOzMzMrOYc0JmZmZnVnAM6MzMzs5pzQGdmZmZWcw7ozMzMzGrOAZ2ZmZlZzTmgMzMzM6s5B3RmZmZmNeeAzszMzKzmHNCZmZmZ1ZwDOjMzM7Oac0BnZmZmVnMO6MzMzMxqzgGdmZmZWc05oDMzMzOrOQd0ZmZmZjXngM7MzMys5hzQmZmZmdWcAzozMzOzmnNAZ2ZmZlZzDujMzMzMas4BnZmZmVnNOaAzMzMzq7k+C+gkHSHp0vL+ZElPS5ot6cRKnmMkPSZpuqSJy5tuZmZmNpAN6YuNShoLnAv8XNJuwDuBHYERwM2SfgCMBk4FdgI2Ay4EDpC0bU/Se/GwzMzMzPpEnwR0wBeB68r7Z4FDIuJ+AEkPABsDrwOmRsRMYKakMZJGAZN7kh4R83rzwMzMzMx6W69XuUraBxgPTAGIiNsi4h9l3sbAJsAdJc/tlUVnkiVvPU03MzMzG9B6NaCTNBI4DzgKiBZZzgIuKqVqg4E5lXnzyGrYnqabmZmZDWi9XeV6GnBZRNwraVx1hqT9gN2BHUrSU7QPyEYCS5YjvR1JRwNHA2y66abLexxmZmZm/UZvV7m+EThR0mPAT4C3S/qJpE2AbwKHVtq8TQd2A5AksrPDI8uR3k5ETImISRExaezYsavsQM3MzMx6S6+W0EXE1o33kvYCDgfeB9wMnBsRf65kvwY4T9INwDbAExExQ1KP0nvhsMzMzMz6VF/1cq16PVnNupGkk0vasRHxY0kHk8ObzAcOBYiIOT1JNzMzMxvo+iygi4hpwLQyqQ7y3ES2q1uhdDMzM7OBzI/+MjMzM6s5B3RmZmZmNeeAzszMzKzmHNCZmZmZ1ZwDOjMzM7Oac0BnZmZmVnMO6MzMzMxqzgGdmZmZWc05oDMzMzOrOQd0ZmZmZjXngM7MzMys5hzQmZmZmdWcAzozMzOzmnNAZ2ZmZlZzDujMzMzMas4BnZmZmVnNOaAzMzMzqzkHdGZmZmY154DOzMzMrOYc0JmZmZnVnAM6MzMzs5pzQGdmZmZWcw7ozMzMzGrOAZ2ZmZlZzTmgMzMzM6s5B3RmZmZmNeeAzszMzKzm+iygk3SEpEvL+2MkPSZpuqSJlTwrJd3MzMxsIOuTgE7SWODc8n5b4FRgJ+B44MKVmW5mZmY20A3po+1+EbiuvJ8MTI2ImcBMSWMkjVpZ6RExr1ePzMzMzKyX9XoJnaR9gPHAlJI0Hri9kmUmsNlKTDczMzMb0Hq1hE7SSOA84M3AuJI8GJhTyTYPGL0S05v34Wjg6DI5V9I9y3EodTYGeLyvdwKA00/v6z1Y2XxuVy2f31XH53bV8vlddVa3c9thQVVvV7meBlwWEfdKagR0T9E+8BoJLFmJ6e1ExBTaSgdXO5KmR8Skvt6PgcjndtXy+V11fG5XLZ/fVcfntk1vV7m+EThR0mPAT4C3Ax8FdgOQJLJTwyPA9JWUbmZmZjag9WoJXURs3XgvaS/gcOCDwF2SbgC2AZ6IiBmSrgHOW9H0Xjw8MzMzsz7RV71cl4qIOZIOJocxmQ8cujLTbRmrbXVzL/C5XbV8flcdn9tVy+d31fG5LRQRfb0PZrUiSeEvjhmS1o6IOV3nNLNVzY/+MusBSecDJ/X1ftSZpPslvaiDeTtLelkny46Q9D1JwytpUyqdrFYbkhZIankNVxrazfUMkTS4eVlJa0gaLWnN8hrZtNyrgBua0q6V9PLlOJzVlqRhkoZVpl8gaa2+3KeBpLvfg4HAAV0fk3SRpNFNaZMkfaeL5baT9O0u8rxC0qd6uD+7SNqlMr23pP26sdznJG3Uk231FUkTJM2XdGsHryclHVB+zL5dfQGvAo5tSv9WZd1rlXVPL68Zkh6pTD8u6e1N+7OdpDkd7MdevXt2VoyksU3H8LUW2RaWF5J2l3RGZd7+wJ6V9X1P0usq819H9l4fWoK7icCu5LiTHe3TgDm/TeZHxDI9+YuNgJsk/UHS75tez0haIml8yXs88BdJsyXdCTwK/AX4APCL8roe+G3TNt4PfFPS+pJuKkHh0v9tfyVpQ+XTilZkHetXr5NN83p63f068D+V6SPJ4b062vb/SDqmvB9SDeolDaoGh/2BpAvUyU3aCqx3REf/g0qeCcC/1P4G8BBJl3eyzLskndMifSNJN67IPq9qfd6GbnUmaR1gF+BdJWj6DvByMmgYJ2ka8N2IaAR91ceZDQcOliQgyOD82Yg4spJnS/LC3mrbg4ChETG/TA8BBDwJXCRp75L1TOD9ZTuDImJxB4czF3g9cEkPTkFfWQLMiIgdWs1UPmN4AXlO96T0nu7EP2i7IC8AHm10o5f0UWBERHy2su7mH7y5wB8j4vUd7EedDAZGR8SEEix9rASw6wKLyc/qWsA7JP0Z+D3wcUnnR8SHyzqWAEj6LLCItqfKQAYZI4C/k21n1gc2AKaXz+gS8rvx3oj4c1lmQJxfSReR14uGNSTdWpm+LSLeA1CemNNuKAdJm5BP6XkE+ExEPFxmfRW4ijyfXwLeAHwOeCAivlCWnQBcXlnXRsBbgGOAA4B/RcRiSVHJM7xxfelndgZOkfQaYHfgAuB58rMzGBgF7BwRT5XgaGFEROMaGRELgReTj5rct8X6u33dLS4G3lbmC3gv8Iik75X5Q4HzI+LGEoR/EtinzDsaOFJSI7AfDNxGdjjsc5KOBF4G7CbpwIh4rEWe7cjrwP1NszYF3hwR0yp5Pwi8Ftic/J7fJengiOjoe7wf8IOm8/0q4JYW+/Ei4ETy5mWhpCOA58jv0flk2/y1uzrmvuSArm/tSz7d4lJgO+Ax4DPkUy9OKOn7lLuLQcArga3IC88SMvj7H/KHchD5xa8aBxzQwV3MIODf5EUZ8iJ+Cm0/cHeTP5wzgK+Qwd43yj4h6QfkRW12daWS3lPejgQWRcQru3MielkAmzT9GG4KPF1ekBfZwcBjEfGwpDvIgauHk0HGQvIYjyJLMKrr3lDS78v0OGCQpEYw8SLgyqb9USf72tm8/qg54F9MHsMg2saFbPzoKyIWSDoEOKr8YOYMaXPye3BEo72ipD2AYRGxV7nZ+SPwfeAl5M3ElhFxevlRrBoo53dT4LMR8SMASbMbNyWSdiADk5YkvZMMBI6r/kAW25CB3Nrkj+/65Gd6X+CBSr5qu9EvAMOAZ4F3AxPK92ki8H1JzwF/pX3JU78QET+TtDWwbURcS15TO/JjYOMSqA4lr39fJK8BcztYplvXXUkHAmdRviOSbgG+Rt6sHFdZZl1ghqQ1ycD74xFxfzmWr5IBeb8j6Y1kKe5XStKvJb07Iv7alLUnN1w/B34JnEw+6nOa0n3AMyXP2sBWJYh7D7CB8glVkDcgrwBeJ+mwynrfCvyLvHl/kLy2f4SsMXi+bPcg2n8H+h0HdH3rUOCpiJgraXvgdOBa8ks/jry4rkuOsXcd+YP4FvJLsgjYsOQPstppM/IJGQ0TgQ9HxJVd7UhEXClpFrBO2c5ryJKP75I/egsj4vrKIs8Ax5IX/P0i4psAyuqzq8ngtMNqgz4mmkroysXjynIeRP5YLYqIRnugSeRF5E3AvhHxeLnbflNEHFJZ9xIyCNy9rLdVCV2zIWQQeGuLef2xhKMzS8gfwFuBNYE7IuJ7kl4YEf8CkPQh4NslUL6f/CwtpH3P9HeVv7dIGhYRW5IlJ2dJ2hV4H3nePhgRs6sxXIsOKwPl/HZUvdrQ2Y/NC8lzPq3FvEXAvWQA/VMywFgbWE/Sj0qeYeQPGyUA34ys5p4ETAC2iYglkn4OfCoibu3G8fSZiDhb0nhJx5PHXz13g4DnIuKSiHhjdTlJL5F0MXmd3E7ShcDWwKkR0biJ6+519xoyOLkdeGlZz7Vk6dqWwLbAq8vrJeRvwWXA7ZL+Arw2Ip5edrV9q1wXjyfHmd2PvGbeQgapV5bP1HmVEuJu3XCV6/JDEbFI0oKS1ohhFldubh4mS9heS/4fJ0palwyUZ5MlpFuUvBOA30fEvWX6GPIG54XAF8o+Plx+n3dY7pPSSxzQ9ZFSArED8BtJW5GB3czyIdyS/PBfDrwyIq6QtAZ5od2cvFsA2B74FXmh3x74oKSLIuKhMv9FtL/D7taudTP9U2Uf9wROl/T+sh8/Ac4o+Y+jfxpBVmlPr6RNAHZXtn0RWRJ3bLk4vYEsAbqMfBrJtpJuBi4Cxkv6XUTMKusZTA9FxD3U4GLRTUuAmRGxQ6ly/bCktYEbJO0bEXc15V8AHFC5uLdTLrhXAUTENaXK6UcRsWuZ/wVJnySDx5GS3gBsAYyPiHlluYFyfgM4R9LJZXrNymd4JDALQNL+ZMlP9eZufJn3hkraqJLvHjKIGVW2sTOwHnm9eb5xc1JxE/Cb8vde4OBO2vL1K5I2BG4kg9OLgSfI4/wKeU17kjwX8yUdCxxG27VvCdms5TWluvZdEXFcqa2oNqPo1nU3IhaqdEYpwfC9ZInS94GfkVWLnwC+TN5Q3yPpn2TQdzkwUdLV5A1R0FZ7MBT4XkSc3LzNVa0EPpeSNTvbkjf3kDUZkNfe54G/S3pNRPyN7t9wbQhcIWkRsCNZY/UsWXDQ7vNXzifAp5XteD8PfIwshLhc0unAHcA/yeYFje/N2eT3YATwcklPkgUoh1KDeKnf7+AAtilZL789WZS7iaQfA/eRJXNbkB+qK0v+4eSH+/fkj+Bi4ENkQ+XG+z/SVmUI+UX/5rI1UABsDFwUEWdAPj6F/AFo3Km+oGyz8dy4QZLOBfaKiNnkRe/P5EXw3eTd2GLgLxExuVSP9Y/n6y1rLPDniKg2vr+UUkJXSVsb+CFZavEGsjr8d2Q7wSfIIGLLphKh4cBGlR/aDchzN7lMT6BS5SrpAUrJB3nOTyJLZ4+l7X85MSKWNurt55bpaFXGiDybvKif0DR7EYCkd5BtRB8o6S8hf9D+Q/tq3EW0na/G9g4iS6gbVa4PUKpqBtj5FXBSU5Vro63mDpQq14i4mrYfUsr8k8u8zy2zUmkb8vz9ggzuHiSftLOo1U5ExL/LcpDn/gRJjXP8QvIH8zkyyPzfiPhWq/X0hdKG60XlfMyOiMskbQH8MyK+onzW9/crJV9fUbZluywiqk0rqs8PXYv21a/dvu6SJZ/jlU00No6IzSXdFxHvkXR3RExVtjGbXfJ/kvxevLVchzdurFjZaet7EdG44e8L/ya/4zPItmjN+3JkRJwi6YxGu7bu3nBFxKPArpI2AB4ig7Q/RsR9at+xqpH/+hIwXxMR7wf+LelRss3zZcB/y3fp9pL/auBqSTeRtWI/LevYnOzN/daenoze5oCuj5S6/wfIgO5HwBVkMfVt5I/RGuQXohEsrE/+AL2QvGtcTBbBTyW/PPcAN1WL4CNi/462L+mr5N11I29zA+rjyKdtfLeD/X9E0iiyI8c9wN5koHR+uZBdStdVRH1le+BuZRuP00raBNpK6AA+Uhohf4K8az6CvFvekfwR+xjZPmhXsqSiYRxwcyNY7EaV64JSndj40Z1H/v9PrVRj/3MlHXdvGEz7KtdGidzXW1SFVi0Afh4RhwMo28h12GFB0nq0lUy00kgfaOf33MpndK1KqcZI8iZjeYhsInELMBn4A7BXN5edWg3Y6lLl2uRD5M0a5Hm8gNKpQNkZbTvgGkmXAZ8uAe1W5M03ZPX00oCuJ9fdsuxfI2KPFp/DQeU6/EHgraW0+s1kW69+KXJMwt9IeiEZ8F7ZlOV9JV+jM94D9PyG6zPk+d4KOEnSzp3sz+JSoteYnla2uwVZzd2Oskf9RLKw4hxJH4mIL0maQV47RiofYDArIpp7ffc5B3T9w+fI0rW7ySEDhpGBw620FfdvSQZ725MNkq8newXNIouDL6R0ilD2ZvsL2Yi/OagaQbYF2wxYOuyJskfhvmQRdpDVBs9Jel/JMgS4OyKOLKVv55T1vwTYhLxrbNi8bOe7knaJiP72g7kneaFZhwwiTq/OLEHXGuVifiZZjfwd8kJyHfD/yDvjM4Gpkg6KiDvL4rvQogdVJ1oFvc1p/TUwbmUw7atcT4KW7dqaDQP2U1tnkm1LWisjyf/fJ5tnlLvptWgL6AbS+R0KfCxadIpokDQkIlqWrHXhOTKoa1hAUzOL8iP4cPTPnqvLRdIBwDvIdlJ7k8HEWyVdUn6wTwS+VKrw/khWUR9C3sgdW1azFjB3ea675Of8KeVYac3n9SEyaNkhIp5VNvz/E3ntr4OXAN9sSrtH0thKE5Ue3XApmyRtT3ZWuZa8aewwgK4qv0V/krQleW3ZX9J6EfFEmb8uGcz/L/nbcARwTPkNnEh+/15Q3t/Zaht9zQFd/3ARWTS9MxmYrUV2e/8C+SHaBTiYbET7c7JU7jiyeu9zZCB4fET8ByDyGbYbdrbBUkT9QGM6Ij5FVp8i6SVkZ4h7gB83fkAqbiV7AP0JuKu5jU0pXTkGeKbRjqm/KNUXryOr/94AHN3UrgiytO475I/cJWRJ3JvIc/5ASfttRPxR0ueAP0vaLyJuJKueP1tZ11DK96y0L9mCDJobBkm6u7x/AfBRshrxzFK6B6X9U03MJy+0kNXTf2jMkPQC8ljWo606TwAR8T3ge1Qo243uQPtSuC3I3t3vjojflbYwkOdsEHnuvx5tw+sMpPN7EE2llpLGRES1acMlkq6LiKmVPMPJ60HLdopkEP4ySluiYvOSPqKSdjxZKvXlMj2IZdvWqkVafzWCLEWaSgazN5Hf72+TvXYfJkvl75F0FPBfYPtyvVgnSk9TSkBXAoMeXXfJHpd/J29SmkukrwbWj4hnASJiLhk4LtfB9oFbInukH0Z+ni4kg+dfSnpFuTHo9g1X+V36Jnn9bjTd+HAJti+uNHNZv7Gg8mQNUrajG6bsTHIeGVxvSDYPeGPkUDSvIj/b/yWD6NuVQyv9nWxvtw5wbUScuyInZVVyQNe3Gg3o55AlbZ8if3AWk8MLHK4cKHJPsrfQiWRj2LlkQ83byMaz7wU+r2zwe0kjsGtWfiD3JoPFMWRpYHX+SDIQO6S87iM/8G8i2/tNjzQHuFkdjFLfWF1/C+aKecBZpV3XcGBKByV0w8gOEG8Dzi7VrxuQbVl+ThmTKyIulvT70mB5PDAkIv5QWd0/aBtO5lCyvcbvK/OHRcSEst0TyO/kMNrfoTZ3JOi3IuJJcmwsIhvKVy/OS8ihb/4v2saj6mwQ1EPIO+bTK2l3Au+MiO+X6X1KtcqryXN5SNM6Bsz5jYjnmpJ+BPxNUuP7PowMDD7RyFDaEN1LNto/uINVD6VS3V2Wm0beeGws6XYy2NiEbFvXMKQsW+0QMLy8+qVyzTqOHM9QZInbOZUSI8ghQtYgP697An9rBFXK9oaXAccrn+awGTCys1LLjq67yjHuDiNL+t5CWxXj2sqBbz9JtumaAXy1UsrdLpAuxzScDDj6y7AaI4EhkvYl9+m/wM1ks5xdK+erJzdcDwKHRMQ/G0FttHXGeTza2pM+XCmpfhEZcD9BFpD8gBwz8bsl7w5kh60PRMTPStpbabvRvLRxQF383vUPEeFXH73IatUfkneG48lu618u03eSJWH3k8X7bynL7E7eWfyXDN4a69qM7KEzsottXkb+qO7ZlP4N8g7+bHJg2Oq8NwN/I3uAbVZJH05e9H/f9Hoa2LSvz283zv8Q8ge/J8uM6Ov9Xl1eZLAwqK/3o+6vFTmH5TuyZnkNbpo3qq+PbTmOZ3OyI9kGZHB1brnOPkIOwzKrXNMWAGNaLP914APl/XFk84r/6cZ2l7nuktWtV5DBzw1ks5Wtyj68o+SZQNbATK4s9y9gg8q0ym/Gn/rLdZcMVJ8la3r2KGkjyCD1P2QvdMjBqxvLnEDWhnyK7DzRSL+rxfovJYePakxvUXm/dtO5mVzevw84o2k9IpuFbFZJexdwbottbtJqX/rTS2VHrQ9JGhR93O1f0vrAk9FJ+5tqewMzs9VNb1yrm6vRleMw1uaJJrC09HFktBgnT9Ko6J+1N7XngM7MzMys5vp/nbCZmZmZdcoBnZmZmVnNOaAzM+tDkgarRmNRmFn/5IDOzFYryoeyf1/SmF7a3r6STqxMny3pV5UsnwauKkOMVJcbImlEc7CnNLJF+i3K54+a2WrIAZ2ZDViSNpC0nqTRjRc5FuELgbOq6eW1vqSNmtbxNknRxWuZxwhVPA2cIumcMj2fHLS68UDwjwMXR9tgyA27l3xLqtuiPCQe2EzS1yS9t+R/nmWfNmBmqwkPLGxmA9kfyDHHGsHS4Mr7LcgnezSIHFvxkTKvYTb5vOTtOtjGU7QIpMrA1SKfC3kAcEEZjLbqBOD9EXFFGephUEQ0nm15I/lM5+OAnSPirZI+TD5vdV9yrLRxtD0bdCFtT+Aws9WMAzozG7Ai4oWN95LOJp8DObkxrpek95BPXdknIp7pYDULgSURMbvVzFLz2Vy6Bvm84w81pc2pLNcYM2pvSZeU9z8lAzZKid1zavGcz2h7uHnz0zjMbDXlKlczW12cRT7Obb9K2hHkc3k7CuagPLGiRfVsowoXWl9LTyefWzs0IkRW8z4K/JMM3LYiH903oSw/AngnZOmepE9J+jj5jMkXl9K5PYHxkj4uaY8eHr+ZDWAuoTOzAU3SvcC65DOQIas+L6hkmSDp7WSw96eI2LdpFaPJx/481clmRjQnVEv0JL0G+E55PUM+9m8uMIp88PeJETGlsvhgMuCbX/4+DmxJPnh8jZJ2X8nXrjOFma2eXEJnZgPdc8BHI2JCREwADief6TkR+BiweUk/n+xY0E5E/CAi1MXrzlYblrS9pO8CVwFnR8QJwDBgeEQ8DOwDnAZ8RdJV5RF8RMSzEXEo8BHy4eJnRsQxwI+AeyPiiIj4Mfkc0EYwKfrPw9nNrJc5oDOzgW5pGzNJ7wB+DuxBlrqdCfxG0riSJSp5z+2gR+uLJR3QwbzPV5Z/OfBXskRth4holArOBGZLGhzpPLIaeFMq1+QS3P2IfJj51SV5KBkQ5s5GvBb4uqTJZJXuMgGpma0eHNCZ2WpB0lHAJcBbImJaRDwEvIxs1zaN7OFaNR/4MVmS13hBDkMyn+wNW533Y9p3XrgD2DoiDoqIe2lvZyqBZkRcX9LmVvJcArwUeHNELCxptwKPStqnku95YCrZE/f6rs6DmQ1MbkNnZquDQWSJ3BTgGkmN3qajyKrWTwLvblpmMTA3Ih5oJJQerQvLvEVN8+bSvrfrNcCenTwEYkkH8xqJ7yaDzEZp3uKIuFbSgcCxwHUAETFP0nhgfqP3q5mtflxCZ2argyUR8WmyV+lDETE6IkYDvwCei4j7WizTUXu07rZV25+sbh3caGtHdmx4nuzQcH61HR4ZvK29dOMRTwKHkYMIL6oMLHwscFDTYMNPAxd1Y5/MbIByCZ2ZrU5GAJtKml2mR5HDiLQiYE1JE1qsQ8CQpnlr0la6RkQ8225l0sbA5WT16BnAH8vjuz4REc+VsfEWNG3rIuCykt4YNPhsYGPgPZX9HN5iWTNbjTigM7PVRkT8go5rJoY2TQ8G3lJeVSPKvHHAv5vm3d28UknrkSVtnwB+BXwwIuZL2g34IXCHpPOBqRHxdGW5rcjSvKDSEYIM3oaSw6lUrSFpQ+DBiJjXwTGa2QDlgM7MBrpOr3OStga+QD479erKrGHA/0XE4ZW8s0v6MDJwmlCZdyQ5xlxj+sPkQME7Av8A3hcRVzTmR8SjkvYCjiYHIT5P0vcj4l0ly9/JThaNDhHNbm2aHkQOY/Ja4LedHbOZDTyK8LBFZjZwSfoX8NmIuLSD+UPI3qUPAkdGxI0rabuvJIOrKyPiti7yDicf+TVzZW3fzFYvDujMbLUnaf2I+G9f74eZ2fJyQGdmZmZWcx62xMzMzKzmHNCZmZmZ1ZwDOjMzM7Oac0BnZmZmVnMO6MzMzMxq7v8DLuAUCtGer3UAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 720x360 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "plt.rcParams['font.sans-serif'] = ['SimHei'] \n",
    "plt.figure(figsize=(10,5))\n",
    "plt.bar( \n",
    "    result.index, # result的索引即商品类型，作为x轴\n",
    "    result.values, # result的值即销售额，作为y轴\n",
    "    color = '#ff8080' # 颜色代码，可以是十六进制颜色码\n",
    ")\n",
    "plt.title('不同类别商品的销售额柱形图',fontsize=16)\n",
    "plt.xlabel('商品类型',fontsize=16)\n",
    "plt.ylabel('销售额',fontsize=16)\n",
    "plt.xticks(fontsize=12)\n",
    "plt.yticks(fontsize=12)\n",
    "plt.ylim([40000,55000]) # 控制y轴的区间\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
